SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 139501 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 139501 [ RunTime:0.002440s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (424154,304438,39527,255966,185251,39875,216790,705870,53559,831259,351807,960329,678154,174305,164161,672414,943171,15316,3990,181682,708373,872765,853287,1040455,1003001,1003644,125479,129143,402280,121370,804370,552785,177693,64112,84728,308849,907690,327968,120919,254069,1003777,951518,441726,674868,983556,200829,687621,616018,682165,619499,79168,663975,744650,727276,268856,149973,311366,478357,213397,295813) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003221s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 139501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 139501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000434s ]