SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410047 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410047 [ RunTime:0.001864s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (285979,575563,272989,590834,411521,972479,465311,666302,251691,314899,559094,474201,266038,19715,709008,401666,305545,716014,236642,144835,515694,559020,569356,49460,393312,50045,670225,804998,232793,797650,364789,408704,425520,832716,365014,613161,303721,573871,732848,276812,834050,324894,205798,1046147,979280,91328,452826,427955,392941,305202,553566,134030,200059,274119,335792,576992,274528,1005371,97774,524101) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410047 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001475s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410047 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]