SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 4434 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 4434 [ RunTime:0.002431s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (470435,364622,569148,44360,385679,127202,776756,720187,575561,881006,458087,846642,430172,1042809,619393,31078,845293,263181,1006113,997799,301574,596708,469066,225954,298419,738705,598953,206011,722382,84621,985460,798409,926549,761404,876359,56704,67685,629280,145520,169914,35914,458058,1045198,539744,165600,189586,560507,464856,666256,95307,769442,112549,750863,62375,584117,776592,29481,1027222,209073,398776) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 4434 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 4434 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000385s ]