SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403439 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403439 [ RunTime:0.003864s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (97891,420665,54436,425068,400772,762932,192598,170474,97330,667732,80639,303048,623807,42115,690460,302019,539015,845412,663947,1010265,61211,307580,920306,90774,440898,869797,498407,437095,939731,901389,348642,259428,453635,429318,78001,322892,838017,872989,183691,515247,414439,737881,1007144,499098,754307,54499,926145,626227,525793,60904,875508,651998,494658,675306,727540,607609,801623,997153,384390,589400) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001513s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403439 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403439 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000622s ]