SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001293s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 51988 LIMIT 1 [ RunTime:0.000480s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 51988 [ RunTime:0.003300s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (840162,351991,501802,146159,317682,399374,59014,645430,754512,714789,982489,136893,222887,845458,412810,601378,243773,304925,238336,377354,502226,933495,261268,982653,248926,92600,294876,898664,371031,5045,426276,793676,547861,101990,237045,439019,135184,682396,506052,240269,440055,58876,438807,521389,661226,44190,424050,547798,741489,741708,684697,130450,444193,564640,286671,459155,806822,1007732,77533,774266) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 51988 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 51988 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]