SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102618 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102618 [ RunTime:0.003084s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (191272,298986,495349,529824,287591,162845,132688,325228,265556,354400,1024831,65492,234057,307524,94333,888139,265297,754126,556252,131870,495382,20724,378323,309713,614583,418878,550534,863652,1007886,927231,84885,144554,641381,313749,396208,643231,158552,275932,408661,874944,902086,976843,594672,857350,617781,94171,106345,549411,839288,215976,499169,1014280,151395,136895,46254,1005464,425093,756870,611902,460) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102618 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000658s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102618 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]