SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001675s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 342680 LIMIT 1 [ RunTime:0.000426s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 342680 [ RunTime:0.002375s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (613622,757513,515389,313995,136334,641535,107563,500315,72416,412570,172567,297572,538812,236869,13002,197034,699783,424144,9921,852796,475620,224359,84373,122452,434746,852543,853224,650659,52008,591947,829189,471433,771540,332448,501349,351509,1022498,630792,500123,349543,530484,169217,394791,325250,782795,917548,875889,69411,370954,810988,242786,33521,398363,388990,849930,712781,943816,39533,930795,120388) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 342680 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 342680 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]