SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002413s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445601 LIMIT 1 [ RunTime:0.003733s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445601 [ RunTime:0.005091s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (864227,765124,516728,632702,439314,242078,39956,717269,30247,1727,25773,798580,223276,1002679,214021,1038501,599637,2676,550703,681453,293539,357669,391796,100565,675271,566231,372006,68409,100800,355548,917519,917425,304151,666520,619848,9331,325494,164745,969699,231758,402262,514329,120527,353917,786074,82110,309366,167680,922666,901535,1030618,880698,173149,759396,962606,215615,583964,746641,314817,250873) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445601 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445601 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]