SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034666 LIMIT 1 [ RunTime:0.000504s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034666 [ RunTime:0.004374s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (112936,384245,1047697,484681,726695,211844,1014558,324436,221409,1033600,173282,967671,140350,890437,198717,265395,779557,111747,848408,1024659,791888,315355,712677,316882,95336,941650,1038493,892852,97286,872836,834005,663396,582850,680574,806931,73940,834247,946575,411049,968258,826701,689072,345603,111398,337423,392982,71847,147722,92984,550437,775921,820271,233270,420493,1043583,694495,608493,732231,626901,285414) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034666 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034666 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]