SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 479984 LIMIT 1 [ RunTime:0.000278s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 479984 [ RunTime:0.001385s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (692504,429248,420937,409722,94415,748969,754450,31380,413334,594500,820452,584266,268004,632027,695014,896008,300288,298584,723148,191650,532829,322199,1046316,332488,66379,223121,668925,144403,879694,435570,765579,99332,585144,505510,1018365,528127,707587,697465,758308,3577,921137,38355,1003947,842768,532238,718267,69943,181218,77842,438720,648678,650824,1046180,431250,598823,679520,141603,289739,689269,253153) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000953s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 479984 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 479984 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000467s ]