SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 424740 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 424740 [ RunTime:0.001601s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (648869,45944,3862,349613,450150,61418,143365,555161,268712,1044228,634342,651018,742698,498155,649672,300197,292496,657612,624179,356506,874670,524768,796137,217845,1037464,107522,127819,749688,474946,15342,114245,574792,696043,63052,261620,230350,661015,603784,324065,62487,844435,103874,738671,552249,1019345,9105,460201,420521,771381,225877,1030951,916826,625783,560716,628591,808750,488199,718399,954555,841592) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001297s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 424740 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000773s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 424740 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001220s ]