SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001497s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543881 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543881 [ RunTime:0.002746s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (827102,572848,583311,613580,438852,871585,670840,1013428,999778,852815,79636,480134,8956,835622,699661,587646,51539,576547,552606,103105,686856,637991,62382,488749,972334,44793,67396,319099,769019,742430,553444,468838,999790,85131,587391,118138,2242,1035009,123190,1036816,988984,402534,901105,647695,803973,575038,303859,174050,984652,732859,634138,383091,206962,759105,28032,688928,227822,454333,776366,322637) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543881 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543881 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000657s ]