SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002336s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 465083 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 465083 [ RunTime:0.001848s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (27319,889830,656461,450042,52408,895643,567851,416354,735852,307785,1008288,280376,376301,750919,342634,296208,1026647,178673,894749,791170,1026048,550473,148496,1042815,110884,824838,15317,896012,652841,230851,605822,983778,483347,720063,925809,923296,694789,387092,25994,520708,35710,517327,674082,614289,505998,302061,1010724,240616,664527,767322,646879,901944,320080,78550,913683,647758,467574,146223,776060,56538) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001679s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 465083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 465083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000673s ]