SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001588s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504575 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504575 [ RunTime:0.001783s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (873083,1032006,253551,793998,718574,246408,749531,404918,788898,242753,917412,821542,772410,711833,231264,92669,563409,394695,1007356,402718,895027,663220,130353,91969,415019,317650,429344,1019976,139054,230082,56539,374552,385950,1007286,572681,865748,540294,622212,775641,235924,385071,96022,604235,330825,419045,942943,826753,30476,490997,287073,368929,170205,308137,475115,997401,55067,939527,677073,753733,356389) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504575 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504575 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]