SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001456s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 610815 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 610815 [ RunTime:0.001806s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1004931,57428,60335,345686,597403,79400,100725,396144,284630,25826,721189,1043416,520406,860445,924906,150657,900543,17343,773883,260501,791258,958651,2945,577684,918729,96334,33818,667282,267026,800045,765493,1035802,1033055,715521,271664,834115,306942,827281,631381,700438,589368,503720,569199,864622,971055,333730,883038,925354,85043,343031,25482,1047053,295156,614204,320633,600548,371370,123800,535888,119411) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002625s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 610815 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 610815 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]