SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003528s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413985 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413985 [ RunTime:0.001794s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (241959,801127,200269,735709,540780,578227,664029,958600,470599,812029,500051,1033482,906599,900982,300067,807918,637175,243109,1040342,138823,129744,867328,976871,744747,176930,991941,554105,869083,569990,360380,160668,806583,431007,341610,589799,69767,978547,688276,939852,879926,491611,503585,475826,248287,1028070,761365,947542,127998,32093,523619,487752,1014787,563372,662384,317011,498075,293471,925411,329550,779169) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413985 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413985 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002963s ]