SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001504s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 355451 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 355451 [ RunTime:0.002084s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (295276,919314,982848,190520,796881,50488,710819,986670,1048847,153114,548067,122682,769335,117889,385336,307398,416886,1017737,636886,831511,408249,238675,425580,1012607,237413,154217,936864,524720,6989,358885,859369,333097,124966,391411,452467,150905,162731,809681,884090,693037,125530,278965,1040856,414053,375887,504344,80493,663643,497147,714620,436756,549507,749451,150409,649803,414494,953377,164270,175202,1022351) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001873s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 355451 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 355451 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]