SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028247 LIMIT 1 [ RunTime:0.001113s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028247 [ RunTime:0.002650s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (79321,634808,306170,284424,147629,850847,772749,779331,226408,262921,738949,711441,754610,899823,776709,200462,429360,750534,97680,232456,1037002,776724,884006,376894,162291,537011,665439,630091,981854,164353,195327,275717,604521,266440,580522,413201,978320,973689,635066,980148,339863,1018849,36074,227521,990058,1004642,869098,806152,922946,660964,215667,564460,415007,193997,600402,263905,906887,803022,226903,636398) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.013851s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028247 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000487s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028247 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]