SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 814208 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 814208 [ RunTime:0.001980s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (600041,40818,312655,842091,1020571,881684,35057,906457,862518,744683,907357,279843,669983,6007,828274,771751,161202,302748,919426,45740,143002,823219,977703,938588,1042176,919291,671402,331143,973201,674883,332313,205249,615683,715385,481950,287775,911861,357145,815114,545514,382503,438014,921193,392678,505676,35032,225808,675712,364582,347333,352717,495584,331157,992070,193758,911855,452360,463421,1000441,811988) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 814208 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000593s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 814208 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]