SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535681 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535681 [ RunTime:0.002191s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (488741,280517,335218,449713,309794,94782,365091,230103,936628,403337,252642,921587,86928,810340,402577,465427,524823,775160,577499,738056,368150,514775,752241,73976,692911,333685,546911,280462,321537,528980,233685,825577,1009275,288245,971608,1015036,344834,673779,600151,326648,724497,814277,673187,824335,3923,294744,336258,1014723,501491,175691,525565,105880,740864,246393,468135,573816,42810,178507,225813,188879) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000977s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535681 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535681 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]