SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001938s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 550185 LIMIT 1 [ RunTime:0.000428s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 550185 [ RunTime:0.001871s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (445299,772748,267263,570340,1048369,536404,108472,155073,211678,36433,136997,712046,307545,447208,869904,191821,410838,245833,444843,169739,287082,42020,429438,230373,592245,828704,682410,479580,438714,522503,688902,650292,601925,133285,351763,538115,346152,717308,924166,93871,239754,1000084,830112,219980,448990,196377,147748,123727,864016,545058,447502,241229,769862,602275,757044,276090,46678,751441,709847,724459) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 550185 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000501s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 550185 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000420s ]