SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 221014 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 221014 [ RunTime:0.004423s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (564277,673854,11462,208620,250207,330456,7152,909066,493676,311207,312175,1018264,532278,852779,437629,583846,147637,327960,346710,266085,334954,309683,391280,737730,764790,114976,165293,436936,951837,127581,645044,472773,1017723,277107,156277,693645,672764,313484,763057,648033,344540,367570,295589,334320,700190,618112,798050,78470,156837,736828,55537,355749,570325,48211,956267,1023266,845900,635940,832260,384628) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 221014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 221014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000413s ]