SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503006 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503006 [ RunTime:0.002733s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (784447,916790,994677,955759,695700,31799,490488,587692,163552,16843,217732,9745,648195,339916,697175,925770,760942,585610,952404,880214,612329,305424,965795,143686,500491,136974,178103,218098,161164,591288,778321,687767,988506,4666,388049,903087,217551,196632,11229,1011154,213520,908816,920929,608823,334953,347485,357534,65538,537894,173652,197840,540996,852784,451384,1045043,675277,9989,728039,330125,525346) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503006 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503006 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000468s ]