SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001766s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341100 LIMIT 1 [ RunTime:0.001114s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341100 [ RunTime:0.003307s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (636458,18196,998203,914732,851290,628733,621112,231904,345201,959760,942595,290651,802286,256098,267301,642854,175052,944744,68592,243146,250484,110428,355734,718389,662184,177000,414364,217530,189013,1423,522798,765872,958890,965317,653455,1042595,346181,281366,797681,730811,21966,670234,1001925,271167,818899,178588,106205,501214,187227,693423,313806,159546,170895,14305,256073,381524,1039111,106287,298944,15143) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002732s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341100 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000475s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341100 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000425s ]