SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 448786 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 448786 [ RunTime:0.003719s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (644516,293109,174205,226834,624915,291009,1010589,545882,74778,886200,666397,727838,852549,590447,294073,314315,887579,298541,702535,239019,26854,742183,1048456,752637,989028,659900,908057,599163,847649,226472,1039661,262468,762399,653616,1007440,1042149,106588,831371,624913,503845,900783,859323,384598,367348,658198,15153,323965,970871,635970,370819,729554,62468,560695,181109,277630,965028,744608,81746,177683,905984) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002919s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 448786 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 448786 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000601s ]