SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001997s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 46190 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 46190 [ RunTime:0.009539s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (480873,783711,762594,905378,342367,847474,741579,783418,334358,144324,1010417,671874,585001,689099,874692,498570,39510,876649,507630,613475,402131,71045,325374,202547,125683,976776,192035,744437,148401,435915,403428,747279,633349,586964,985116,899230,640814,1021624,441411,91142,487339,946742,400453,689474,715028,425835,41402,623347,2107,1040492,860438,575821,688900,1011268,465477,187793,806969,729631,580753,457836) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 46190 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000552s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 46190 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002012s ]