SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001870s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026012 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026012 [ RunTime:0.003080s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (98004,981926,308014,410971,758216,454134,1024535,914933,486884,883913,32503,469809,666480,228856,735974,40258,915832,120478,452260,476638,167271,1024330,996548,252915,82666,991991,528506,921258,821140,413051,44656,797918,437919,556645,738749,494221,473953,824520,349549,778430,190314,55752,895195,11173,762788,321275,538068,84240,745573,988760,191863,233999,711152,274924,389391,450645,649516,722954,78326,830240) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000486s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000642s ]