SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 500470 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 500470 [ RunTime:0.002194s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (614635,1002719,409053,128940,271805,65108,629343,770132,344775,211954,895781,828942,722211,362122,898369,893692,139254,934126,761575,608900,523095,610872,822011,5675,353621,260719,431124,508113,62688,361094,416236,559816,40599,826804,573107,972762,825531,932376,986286,178130,2862,141793,874375,699903,591936,392592,583915,937312,4723,410999,775219,177849,435211,964259,711880,329934,399560,890312,751013,947000) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 500470 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 500470 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]