SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001429s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 323441 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 323441 [ RunTime:0.001987s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (320451,665854,938111,924658,477880,279621,792377,49088,798187,796678,246617,444152,562032,490275,210789,873074,967899,493863,174288,211376,224718,636531,854462,104843,286639,269059,571305,568192,307116,604417,330812,536683,590165,331756,293245,961395,318279,447907,691253,181174,180614,546785,862369,887688,973393,890962,709091,782963,813984,257060,724769,479611,417211,703673,359718,746631,536474,742175,98520,76616) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001600s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 323441 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 323441 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001392s ]