SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 530164 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 530164 [ RunTime:0.001670s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (262555,809111,206899,369854,46561,652218,691988,488258,664327,322390,116758,79090,744025,701477,315826,392730,440119,411437,53133,479065,641220,372118,987429,210554,816355,971236,995482,877650,617962,1041059,203421,746281,115189,278240,108701,978485,334971,682165,818110,278930,288369,142217,151259,491897,15683,118191,665122,918278,841051,541627,1006371,451961,338997,522472,803253,946029,13247,1030042,952934,250612) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 530164 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 530164 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]