SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 184653 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 184653 [ RunTime:0.001799s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (396247,274554,649185,1017688,326671,273273,180937,596593,313021,297923,959113,934636,59212,276811,156169,898805,102693,197361,109425,375145,441702,132642,534768,772274,426277,772058,245124,412785,293885,463562,857790,953867,439412,167237,493361,85029,513646,45542,835304,143407,969362,388642,380716,256691,621196,204688,730724,957136,160729,689632,1040133,754968,67799,830015,424902,640485,247355,461273,716692,1041151) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 184653 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 184653 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]