SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503626 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503626 [ RunTime:0.001718s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (748346,279003,419336,191216,1030185,795459,116786,119131,774897,300587,746995,76940,129196,166881,114258,467382,111022,298315,831888,22476,921506,884499,338610,492334,630227,130362,425686,791334,657380,967752,593104,52296,721455,76026,55160,980531,1046845,281735,298929,364380,158114,481609,94478,986180,458194,484340,246316,464947,529107,303299,143663,209874,471871,813073,250174,804561,798840,266016,200720,315944) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503626 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503626 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000665s ]