SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1002921 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1002921 [ RunTime:0.002127s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (122555,27743,43869,638,20412,190430,632090,698085,928230,149116,901218,866044,439766,563951,1048565,90376,234037,975329,882529,736681,406633,791069,435103,35526,734308,155757,913218,32531,252167,310918,900221,26446,368558,107455,117474,375428,448616,115561,356790,391280,421806,503785,839307,351157,965992,887815,903566,853521,852688,502595,889741,628087,624403,198951,282312,477233,754507,451558,207778,554835) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1002921 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1002921 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]