SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012698 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012698 [ RunTime:0.001522s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (368981,339103,259467,869382,100478,401908,252384,968395,570554,505077,271948,565269,886361,388022,748068,958551,893574,112903,214922,234362,775392,161408,819798,416160,219819,1039774,62940,222750,884852,793741,481641,373748,735489,983710,586622,300356,620450,328967,726521,322361,596848,356726,922390,412743,1006278,233738,1026571,702626,397417,94835,620195,333996,312969,955121,157086,702911,872785,685603,53663,485933) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000967s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012698 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012698 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003188s ]