SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 281513 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 281513 [ RunTime:0.001565s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (24473,335153,220795,167831,946948,296501,811952,98076,118244,569129,738448,616034,320758,518785,298124,474886,259890,1041181,1011849,480837,508452,31960,728983,528772,170961,988360,492283,467343,743353,528068,576850,680869,668184,771138,685209,140912,242054,669295,824336,855959,781690,92714,1012071,298689,318283,763441,428139,655475,902035,68803,51899,40678,24070,947705,295827,450771,125737,882403,384235,910600) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 281513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 281513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]