SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014545 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014545 [ RunTime:0.001610s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (381269,200086,839580,431737,916529,939403,652807,310043,193169,124926,912559,473353,323391,156502,764142,387619,223206,818679,654415,723113,825797,233268,650470,679134,176076,371676,793517,384389,96594,213727,279260,708572,876195,650152,355433,104947,182201,536507,104245,520447,37964,597975,16380,246885,839308,194316,365725,421714,833083,852680,776208,124305,983072,149144,164247,123931,825369,265828,230766,737128) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014545 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014545 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001495s ]