SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000951s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 596434 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 596434 [ RunTime:0.002548s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (738697,138538,738897,579809,306442,687219,136741,728077,48076,239179,604973,170670,898712,74678,426128,1025440,944427,815880,49429,708669,735731,301540,38511,538099,506513,376487,47503,546606,796409,434542,773841,749037,235384,1040530,342773,570650,863212,888176,876671,163579,679315,237323,970526,1013108,329486,944788,543274,416758,672550,333581,6632,646623,648486,406988,656908,437258,197167,23803,213792,794244) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 596434 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 596434 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000412s ]