SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003562s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 381618 LIMIT 1 [ RunTime:0.002457s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 381618 [ RunTime:0.005254s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (95817,392529,238332,568160,657982,147148,379721,586432,369664,986637,486133,412208,281420,399564,535057,67830,1041941,17005,238787,356545,498281,157054,448080,501598,280635,350551,199472,874896,702247,445070,385426,204986,871716,996089,623547,956340,981546,954038,369104,245380,386070,43281,426792,373376,97569,521641,422082,768999,712827,66721,747278,56867,595765,737850,821065,42468,881163,757376,745463,32259) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002892s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 381618 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001681s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 381618 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002776s ]