SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001337s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421618 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421618 [ RunTime:0.004855s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (221624,110391,719338,1031850,490884,807014,815149,5656,256703,248525,476855,822201,616561,84510,977864,603134,348170,486699,533383,763562,385476,909474,917480,838879,837054,15351,951663,801800,1005340,377522,817480,1044406,558,395157,963257,560938,122476,879121,1035545,579872,875794,885900,936728,156155,72517,431811,582026,84308,904363,81514,854504,688940,799228,853284,746749,584438,589456,465176,469932,1841) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421618 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421618 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000465s ]