SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 279218 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 279218 [ RunTime:0.002004s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (512488,523613,596492,483476,301514,213992,164368,510855,286602,244242,1015459,210467,1036669,186266,486606,98687,206063,325246,215588,342299,601624,84343,686409,519818,486616,133192,41187,86311,949767,168767,1035834,8986,20355,1048870,57148,852172,51702,777237,357606,989854,752365,577698,705262,567096,347199,374280,807119,167908,351238,225180,609894,844958,323566,481783,441925,389465,37288,675886,541497,510851) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 279218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 279218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000484s ]