SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003314s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405423 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405423 [ RunTime:0.002201s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (434924,83001,757362,1027801,752605,92233,984682,282293,981510,608855,849254,1042719,763292,888934,580144,729128,488430,198502,191136,498574,635808,242189,247185,155066,91225,450908,997107,755723,631964,643472,930323,766319,373798,119339,311337,958751,563681,828636,793056,350027,985486,226392,796063,363350,496515,464773,969208,122648,29815,203631,590950,679190,85009,579656,494879,3279,242613,205324,750275,577174) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006645s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405423 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000751s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405423 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001250s ]