SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002352s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 281897 LIMIT 1 [ RunTime:0.000427s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 281897 [ RunTime:0.002385s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1003509,527185,602186,94559,27650,754499,486453,699381,620990,896623,225742,340822,369221,1027109,364019,30311,705698,716271,503154,201860,239579,779771,622220,146026,183662,356506,531144,591325,345330,130385,505941,852062,371041,376062,482228,146304,516708,1002732,1023338,84325,528331,720868,129531,404255,678542,171781,25986,53542,31981,960126,805478,432916,150089,477813,1029560,1014853,937832,757737,864318,189509) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003915s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 281897 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000492s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 281897 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]