SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 464043 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 464043 [ RunTime:0.001880s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (752112,420440,1036659,1011093,1019260,140866,1027024,478161,101163,152226,292326,167349,434155,951266,684329,1422,592136,89055,123453,896714,88124,299091,504499,637150,782568,52861,91638,568369,393701,273376,859087,107252,614164,273394,242358,506118,708198,462973,578199,232445,134701,116876,516211,134860,897083,218875,278068,140734,172856,907737,144222,518007,813179,716037,504174,120743,646809,348964,488414,650807) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 464043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000494s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 464043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000683s ]