SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 394423 LIMIT 1 [ RunTime:0.000487s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 394423 [ RunTime:0.002178s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1025354,58570,578383,1021525,792761,555304,968877,844945,386136,228516,986265,240307,215022,782733,136651,79012,568541,908320,549441,225982,265554,321825,485463,18457,6785,487656,653823,999602,583545,459540,596359,37682,131823,492173,553448,865571,997681,355471,560916,958824,350355,13251,843547,221169,1243,608805,558646,896447,721711,921518,73481,185523,28984,424382,810900,124623,132451,283673,16711,1042852) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 394423 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000496s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 394423 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]