SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 548518 LIMIT 1 [ RunTime:0.002370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 548518 [ RunTime:0.001953s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (801610,1579,825770,107411,906313,924327,779310,965648,351115,779668,422199,1040448,348470,254105,171692,657510,638650,347038,419462,882481,975375,381706,401228,40756,496483,699435,161243,137676,1038703,657701,728518,132841,912579,226152,287032,985670,376707,32742,102941,311286,579816,269210,290192,222552,166392,927906,467087,384875,177141,664874,623055,52684,609576,45387,1016554,787455,399489,892020,1039513,714928) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002114s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 548518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 548518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]