SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001714s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 287851 LIMIT 1 [ RunTime:0.003502s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 287851 [ RunTime:0.008972s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (151087,153724,977302,25094,1016597,283200,492816,1019797,558144,872840,349854,461999,961252,620358,919558,8631,27165,226310,736516,726075,272070,779005,255771,374885,901871,383467,425618,1020475,124656,111829,803125,625918,537445,51411,148475,99754,275895,492605,753117,1042168,309223,529463,395477,497767,619141,218681,354849,772502,312098,956294,88063,266566,913501,100042,646193,992495,104058,36563,988056,950612) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 287851 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 287851 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001312s ]