SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105418 LIMIT 1 [ RunTime:0.000436s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105418 [ RunTime:0.001956s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (449558,832924,433058,99970,737250,477447,109790,787901,725547,51158,908644,681945,69187,778713,940926,1039061,649321,72764,441366,478135,676149,146688,381835,967380,659832,1041506,873384,971442,259943,797459,483984,712490,26084,131000,144,442113,1033403,2506,248512,578314,678975,809633,404064,196891,185555,220222,818530,627235,612202,957326,782437,597594,719164,327618,947210,246766,502476,86687,208425,881492) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105418 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105418 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000465s ]