SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001605s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 529904 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 529904 [ RunTime:0.003017s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (527690,190065,507981,405732,613190,313646,812031,666240,90980,217318,417098,263954,62247,716985,48957,967557,319867,422467,505305,371364,722602,270951,572034,528711,611601,786515,701808,388175,1005481,724673,362387,485673,291142,90686,255772,199947,917433,85775,275083,282952,199305,734878,1045255,246389,415472,266537,884290,174836,845248,58442,348961,100001,411091,116104,562056,946645,1037722,273380,943660,482265) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001507s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 529904 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 529904 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]