SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001434s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34149 LIMIT 1 [ RunTime:0.001330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34149 [ RunTime:0.002887s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (245487,728497,194032,571869,484783,584794,422484,362525,189150,384093,101492,856126,849044,536181,404937,826416,978298,725061,951413,316529,664662,986129,868419,535025,303107,226516,1007613,311199,575416,884254,493073,1027286,974352,736761,414387,113434,32787,199347,340212,769938,582641,239624,961717,738204,1017744,488099,731814,663723,224982,202058,611892,979511,436162,630001,1039847,947527,96039,865875,19118,685032) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34149 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34149 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004404s ]