SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001736 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001736 [ RunTime:0.001988s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (774990,238915,915099,912924,948640,535099,939238,150116,81428,415113,681140,113586,506532,571908,286237,633966,361657,737938,1031324,240489,669561,535141,44689,35411,435351,403488,397394,139469,728897,496460,640684,236291,61575,430288,192581,774130,998414,154157,596570,80633,457295,685480,517459,837441,712367,377019,1033856,865309,899757,72339,957486,528168,771511,190685,517074,579438,813284,810251,548043,343433) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001736 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001736 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000505s ]