SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 860681 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 860681 [ RunTime:0.003124s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (4823,575635,590735,190662,638664,431306,264659,150238,121523,33484,940542,125934,101352,828914,65901,448920,1041279,623316,195999,300760,610533,228192,842024,291922,188217,916810,373195,565544,384262,513739,1045662,900835,332220,565566,738488,334372,456628,392469,1044563,300164,644670,620473,218946,244963,510071,155317,93738,286358,543347,1028866,16957,319543,103333,143815,77183,195145,419900,429131,460408,550085) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001593s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 860681 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 860681 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000456s ]