SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 26381 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 26381 [ RunTime:0.001659s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (429710,1045716,812509,270562,743673,260865,369978,315532,531149,192258,693962,619854,79461,605902,817310,745841,338169,376531,764200,511501,852139,40534,363348,174119,575506,621108,676362,917658,307432,37735,730034,230681,397702,357048,543437,460758,525105,162434,46662,937417,670879,418962,514856,268734,1043990,593435,1036816,318567,535088,697220,387533,368695,6878,752738,9296,425025,614910,573442,150950,643329) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 26381 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 26381 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000660s ]