SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 56551 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 56551 [ RunTime:0.001846s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1026713,622330,160593,472864,182478,129684,644628,580763,779538,510757,403520,723239,594231,368796,19690,494490,754246,176188,83619,481488,916589,185097,666245,239094,155849,330719,800722,486609,1011780,386766,422718,900151,64074,1027985,605328,715578,1017631,669995,843658,722521,886140,615829,281558,71112,167940,228802,901065,429265,504712,325233,843967,840866,1017170,827275,503058,837648,542072,372751,592178,471612) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001980s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 56551 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000485s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 56551 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]