SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 967840 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 967840 [ RunTime:0.002014s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (662118,313239,415626,678344,541130,129201,972927,466640,794989,230536,38072,739531,976471,36419,1033657,615656,861455,639122,252391,482052,237218,598146,311305,172438,404378,570359,819383,521723,290094,775640,572252,491895,240040,438190,766481,685190,577873,496192,627513,771047,492801,1021924,339101,386468,189365,351381,180464,623154,52455,789993,752949,642678,308308,823172,241990,50980,46977,987738,34462,74404) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 967840 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000472s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 967840 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000520s ]