SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 570843 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 570843 [ RunTime:0.001734s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (348178,302377,634857,482972,567227,877449,905299,518655,620332,385619,41573,876561,285658,514859,732931,1019981,968256,319233,127311,647841,1029592,459109,992561,1036668,311902,855291,85406,986963,916906,409897,816243,701604,1045179,194897,75295,917991,527332,4329,699716,549140,765738,871609,342795,576871,703124,818284,819108,395971,201775,807027,191814,584526,356678,491521,1007843,657865,623537,53108,150583,114458) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 570843 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000570s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 570843 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000493s ]