SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 146759 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 146759 [ RunTime:0.002114s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (675748,469096,251228,380406,19209,522049,876691,804492,928,481381,562809,187076,617109,339961,338285,918867,829754,678450,958593,943183,366458,717695,700014,647498,850160,458749,806140,952192,443091,417685,300442,157560,223808,1024488,966211,332953,635463,473024,696028,47968,155543,918320,948051,790787,127973,109008,385536,864674,80083,592250,836264,537893,799275,498553,852416,199438,77386,895347,903965,255815) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 146759 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 146759 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000656s ]