SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 644716 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 644716 [ RunTime:0.003637s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (367860,146994,835818,11048,77138,887352,268702,367927,892947,838,564393,644602,144870,192743,350456,491013,318777,380329,62249,51407,745138,187561,407335,505402,745302,685080,976656,310575,840318,209256,481817,881109,744423,505739,1022585,219694,500481,468070,590732,180050,608748,60225,124500,986735,49812,753000,197574,684568,532688,651172,538329,578409,617280,755973,611997,759239,273916,293094,393285,279055) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 644716 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 644716 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]