SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1030203 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1030203 [ RunTime:0.001695s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (375486,559015,771087,857819,411195,376599,607608,144174,270158,494966,613954,538035,646391,674893,980090,377981,136577,63955,352566,900810,330077,863249,287743,1044727,551876,117066,814843,204741,88925,270207,159189,795679,17349,103280,745051,1003029,131675,703836,627444,888868,922015,989990,349094,849682,643323,698223,374433,303100,779247,640138,621934,67921,443568,292834,952630,441744,6419,150011,32426,42596) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1030203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1030203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003430s ]