SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001315s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 488028 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 488028 [ RunTime:0.004231s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (319553,351396,441262,810384,677148,717268,408557,527432,425311,317298,296316,330033,734437,862155,288593,595878,126188,401720,1002961,791560,626258,281243,900483,696720,215218,421752,783512,850002,539194,86931,593319,380648,340303,886814,415816,324089,480609,448078,342224,755878,799962,455277,51363,135852,831889,531336,214430,728318,809312,202043,157610,25155,458700,974850,607208,500984,22062,852918,841081,212598) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001731s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 488028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 488028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]