SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005547s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 602013 LIMIT 1 [ RunTime:0.006458s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 602013 [ RunTime:0.003573s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (434879,783036,461886,667043,635946,190714,759022,150153,142906,27737,427153,745608,641719,1000072,149082,85623,150948,623032,778340,168019,226447,619531,263331,41426,663401,30934,735354,434080,387290,871809,750453,586264,640702,1047557,234297,317356,443048,743508,429774,831310,422061,770487,364303,704255,350785,7130,584441,262116,1024609,788923,674350,415415,796938,791823,784638,688877,11988,721911,911057,304351) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 602013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002536s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 602013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004742s ]