SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104894 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104894 [ RunTime:0.001651s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (546529,560940,557787,925534,422219,853200,466309,444589,554928,859781,140623,13626,110760,206034,244559,996100,802743,276502,923703,346828,144188,379989,56217,600138,1015254,673526,319933,968701,142373,91401,989812,672796,987296,8938,177978,641087,732659,69644,944240,462315,884180,823387,711165,122247,1002663,905578,455836,880824,302141,212633,800845,39263,761983,851420,747274,801181,795840,689978,566163,589303) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001638s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104894 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104894 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]