SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034873 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034873 [ RunTime:0.001790s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (356294,884194,723314,664507,580158,370568,6104,112085,866168,1025719,507867,727069,764315,54271,689923,65569,490125,466704,974028,1024269,30561,754620,232591,180875,438813,731252,300006,836917,918060,486997,392243,133690,490148,834302,455654,867407,757599,584544,968878,81,989899,449206,743300,319272,986593,563795,229025,521178,195641,917794,485720,562645,484956,450769,518548,900367,874112,694366,253756,311333) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034873 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034873 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000471s ]