SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 577905 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 577905 [ RunTime:0.002008s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (903968,799875,188676,924355,107142,929373,268212,598856,71163,924732,405528,176974,215928,953367,478464,98828,207856,332159,90951,650130,456013,209594,505213,674980,2493,961360,329751,103970,482069,107060,886139,996533,366496,949788,319787,602158,31147,368883,535184,325839,307559,976083,221607,470374,776017,571406,878242,593440,921461,682051,532259,645071,132196,535120,427094,609640,271502,869244,69294,1043171) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 577905 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000529s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 577905 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]