SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 386178 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 386178 [ RunTime:0.001724s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (420381,724893,249529,774240,399450,142286,532162,386739,1040208,762848,405447,627835,247449,218761,498528,639135,690724,225799,597930,405528,214218,943350,1020128,23014,982312,480239,612665,364664,1003501,1028641,795448,923736,428384,416956,236125,902449,1031455,815368,5939,952177,1007162,181771,387248,317369,157978,1011894,662321,811785,961781,797609,75158,805682,389765,469329,862669,382725,322407,916003,438921,644549) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000932s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 386178 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 386178 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000421s ]