SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014473 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014473 [ RunTime:0.004483s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (184357,145915,863227,112927,3087,1045710,156769,137325,663880,1048727,1019052,798768,1009352,771003,408763,1038884,387240,74824,622715,390570,6197,109215,558022,251510,819514,951724,617153,583507,259167,812751,781445,1032582,550262,513821,584551,989534,875140,800232,937359,749658,639367,21256,824517,567674,890733,372966,911498,486540,505212,942554,922320,1026312,1019034,785480,294655,49983,380185,624311,698394,274313) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014473 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003517s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014473 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000652s ]