SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001297s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502206 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502206 [ RunTime:0.001966s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (558832,753442,435749,570530,486665,341326,918630,915733,176740,774739,567125,597262,266374,703038,684445,197261,691869,819094,283769,336877,526523,216724,766551,736965,817778,737993,848611,166784,948415,161874,877120,881066,991982,291225,873877,977074,1029477,719345,883086,996006,1042418,1039169,932971,489993,680904,1043489,172109,715629,142527,887253,644992,753364,990390,279420,53785,608630,331067,910652,1007368,415824) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502206 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502206 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000445s ]